﻿-- =============================================
-- Script Template
-- =============================================

INSERT [ODData].[ClassificationScheme] ([SchemaID], [SchemaName], [CreatedByID]) VALUES (1, N'Anderson Landuse/Lancover Classification Level I', 0)
INSERT [ODData].[ClassificationScheme] ([SchemaID], [SchemaName], [CreatedByID]) VALUES (2, N'Anderson Landuse/Lancover Classification Level II', 0)
INSERT [ODData].[ClassificationScheme] ([SchemaID], [SchemaName], [CreatedByID]) VALUES (3, N'U.S. Army Corps of Engineers Dam Types', 0)
INSERT [ODData].[ClassificationScheme] ([SchemaID], [SchemaName], [CreatedByID]) VALUES (4, N'U.S. Army Corps of Engineers Dam Purposes', 0)
INSERT [ODData].[ClassificationScheme] ([SchemaID], [SchemaName], [CreatedByID]) VALUES (5, N'U.S. Army Corps of Engineers Owner Types', 0)
INSERT [ODData].[ClassificationScheme] ([SchemaID], [SchemaName], [CreatedByID]) VALUES (6, N'U.S. Army Corps of Engineers Dam Hazard Codes', 0)
INSERT [ODData].[ClassificationScheme] ([SchemaID], [SchemaName], [CreatedByID]) VALUES (9, N'USGS Rock Type Classification', 0)
INSERT [ODData].[ClassificationScheme] ([SchemaID], [SchemaName], [CreatedByID]) VALUES (10, N'Non-categorical', 0)
INSERT [ODData].[ClassificationScheme] ([SchemaID], [SchemaName], [CreatedByID]) VALUES (11, N'Beaufort Wind Scale', 0)
INSERT [ODData].[ClassificationScheme] ([SchemaID], [SchemaName], [CreatedByID]) VALUES (12, N'Cyclone Stage Classification', 0)
INSERT [ODData].[ClassificationScheme] ([SchemaID], [SchemaName], [CreatedByID]) VALUES (13, N'Saffir-Simpson Hurricane Scale', 0)
INSERT [ODData].[ClassificationScheme] ([SchemaID], [SchemaName], [CreatedByID]) VALUES (14, N'Not Applicable', 0)

SET IDENTITY_INSERT [ODData].[ObservedCategory] ON
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (1, N'/1/', N'1', N'Urban or Built-up Land', 1)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (2, N'/2/', N'2', N'Agricultural Land', 1)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (3, N'/3/', N'3', N'Rangeland', 1)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (4, N'/4/', N'4', N'Forest Land', 1)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (5, N'/5/', N'5', N'Water', 1)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (6, N'/6/', N'6', N'Wetland', 1)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (7, N'/7/', N'7', N'Barren Land', 1)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (8, N'/8/', N'8', N'Tundra', 1)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (9, N'/9/', N'9', N'Perennial Snow or Ice', 1)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (10, N'/1/1/', N'11', N'Residential', 2)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (11, N'/1/2/', N'12', N'Commercial and Services', 2)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (12, N'/1/3/', N'13', N'Industrial', 2)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (13, N'/1/4/', N'14', N'Transportation', 2)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (14, N'/1/5/', N'15', N'Industrial and Commercial Complexes', 2)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (15, N'/1/6/', N'16', N'Mixed Urban or Built-up Land', 2)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (16, N'/1/7/', N'17', N'Other Urban or Built-up Land', 2)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (17, N'/2/1/', N'21', N'Cropland and Pasture', 2)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (18, N'/2/2/', N'22', N'Orchards, Groves, Vineyards, Nurseries, and Ornamental Horticultural', 2)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (19, N'/2/3/', N'23', N'Confined Feeding Operations', 2)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (20, N'/2/4/', N'24', N'Other Agricultural Land', 2)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (21, N'/3/1/', N'31', N'Herbaceous Rangeland', 2)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (22, N'/3/2/', N'32', N'Shrub and Brush Rangeland', 2)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (23, N'/3/3/', N'33', N'Mixed Rangeland', 2)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (24, N'/4/1/', N'41', N'Deciduous Forest Land', 2)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (25, N'/4/2/', N'42', N'Evergreen Forest Land', 2)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (26, N'/4/3/', N'43', N'Mixed Forest Land', 2)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (27, N'/5/1/', N'51', N'Streams and Canals', 2)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (28, N'/5/2/', N'52', N'Lakes', 2)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (29, N'/5/3/', N'53', N'Reservoirs', 2)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (30, N'/5/4/', N'54', N'Bays and Estuaries', 2)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (31, N'/6/1/', N'61', N'Forested Wetland', 2)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (32, N'/6/2/', N'62', N'Nonforested Wetland', 2)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (33, N'/7/1/', N'71', N'Dry Salt Flats', 2)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (34, N'/7/2/', N'72', N'Beaches', 2)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (35, N'/7/3/', N'73', N'Sandy Areas other than Beaches', 2)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (36, N'/7/4/', N'74', N'Bare Exposed Rock', 2)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (37, N'/7/5/', N'75', N'Strip Mines Quarries, and Gravel Pits', 2)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (38, N'/7/6/', N'76', N'Transitional Areas', 2)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (39, N'/7/7/', N'77', N'Mixed Barren Land', 2)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (40, N'/8/1/', N'81', N'Shrub and Brush Tundra', 2)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (41, N'/8/2/', N'82', N'Herbaceous Tundra', 2)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (42, N'/8/3/', N'83', N'Bare Ground Tundra', 2)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (43, N'/8/4/', N'84', N'Wet Tundra', 2)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (44, N'/8/5/', N'85', N'Mixed Tundra', 2)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (45, N'/9/1/', N'91', N'Perennial Snowfields', 2)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (46, N'/9/2/', N'92', N'Glaciers', 2)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (47, N'/10/', N'CB', N'Buttress', 3)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (48, N'/11/', N'CN', N'Concrete', 3)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (49, N'/12/', N'ER', N'Rockfill', 3)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (50, N'/13/', N'MS', N'Masonry', 3)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (51, N'/14/', N'MV', N'Multi-arch', 3)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (52, N'/15/', N'OT', N'Other', 3)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (53, N'/16/', N'PG', N'Gravity', 3)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (54, N'/17/', N'RE', N'Earth', 3)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (55, N'/18/', N'ST', N'Stone', 3)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (56, N'/19/', N'TC', N'Timber crib', 3)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (57, N'/20/', N'VA', N'Arch', 3)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (58, N'/21/', N'C', N'Flood control and storm water management', 4)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (59, N'/22/', N'D', N'Debris control', 4)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (60, N'/23/', N'F', N'Fish and wildlife pond', 4)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (61, N'/24/', N'H', N'Hydroelectric', 4)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (62, N'/25/', N'I', N'Irrigation', 4)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (63, N'/26/', N'N', N'Navigation', 4)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (64, N'/27/', N'O', N'Other', 4)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (65, N'/28/', N'P', N'Fire protection, stock, or small farm pond', 4)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (66, N'/29/', N'R', N'Recreation', 4)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (67, N'/30/', N'S', N'Water supply', 4)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (68, N'/31/', N'T', N'Tailings', 4)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (69, N'/32/', N'F', N'Federal agency', 5)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (70, N'/33/', N'L', N'County, City, Regional, or other similar local', 5)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (71, N'/34/', N'P', N'Individual or individuals, or private company', 5)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (72, N'/35/', N'S', N'State or State agency', 5)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (73, N'/36/', N'U', N'Public utility', 5)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (74, N'/37/', N'L', N'Low. Failure or misoperation results in no probable loss of human life and low economic and/or environmental loss.  Losses are principally limited to the owner''s property', 6)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (75, N'/38/', N'S', N'Significant. Failure or misoperation results in no probable loss of human life but can cause economic loss, environmental damage, disruption of lifeline facilities, or impact other concerns.  These dams are often located in predominantly rural or agricultural areas but could be located in areas with population and significant infrastructure.', 6)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (76, N'/39/', N'H', N'High. Failure or misoperation will probably cause loss of human life.', 6)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (77, N'/40/', N'U', N'Unknown', 6)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (78, N'/41/', N'100', N'Unconsolidated sand and gravel aquifers', 9)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (79, N'/42/', N'999', N'Other', 9)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (80, N'/43/', N'200', N'Semiconsolidated sand aquifers', 9)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (81, N'/44/', N'300', N'Sandstone aquifers', 9)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (82, N'/45/', N'400', N'Carbonate-rock aquifers', 9)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (83, N'/46/', N'500', N'Sandstone and carbonate-rock aquifers', 9)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (84, N'/47/', N'600', N'Igneous and metamorphic-rock aquifers', 9)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (86, N'/85/', N'Non-categorical', N'Observation result is not categorical', 10)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (88, N'/86/', N'0', N'Calm, wind speed <0.3 m/s, sea surface smooth and mirror-like, on land smoke rises vertically', 11)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (89, N'/86/', N'1', N'Light Air, wind speed 0.3-1.5 m/s, scaly ripples, no foam crests on sea surface, smoke drift indicates wind direction, still wind vaneson on land', 11)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (90, N'/88/', N'2', N'Light Breeze, wind speed 1.5-3.3 m/s, small wavelets, crests glassy, no breaking on sea surface, Wind felt on face, leaves rustle, vanes begin to move on land', 11)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (91, N'/89/', N'3', N'Gentle Breeze, wind speed 3.3-5.5 m/s, large wavelets, crests begin to break, scattered whitecaps on sea surface, wind felt on face, leaves and small twigs constantly moving, light flags extended on land', 11)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (92, N'/90/', N'4', N'Moderate Breeze, wind speed 5.5-8.0 m/s, large wavelets, small waves 1-4 ft. becoming longer, numerous whitecaps on sea surface, dust, leaves, and loose paper lifted, small tree branches move on land', 11)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (93, N'/91/', N'5', N'Fresh Breeze, wind speed 8.0-10.8 m/s, moderate waves 4-8 ft taking longer form, many whitecaps, some spray on sea surface, small trees in leaf begin to sway on land', 11)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (94, N'/92/', N'6', N'Strong Breeze, wind speed 10.8-13.9 m/s, larger waves 8-13 ft, whitecaps common, more spray on sea surface, larger tree branches moving, whistling in wires on land', 11)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (95, N'/93/', N'7', N'Near Gale, wind speed 13.9-17.2 m/s, sea heaps up, waves 13-20 ft, white foam streaks off breakers on sea surface, whole trees moving, resistance felt walking against wind on land', 11)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (96, N'/94/', N'8', N'Gale, wind speed 17.2-20.7 m/s, moderately high (13-20 ft) waves of greater length, edges of crests begin to break into spindrift, foam blown in streaks on sea surface, whole trees in motion, resistance felt walking against wind on land', 11)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (97, N'/95/', N'9', N'Strong Gale, wind speed 20.7-24.5 m/s, high waves (20 ft), sea begins to roll, dense streaks of foam, spray may reduce visibility on sea surface, slight structural damage occurs, slate blows off roofs on land', 11)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (98, N'/96/', N'10', N'Storm, wind speed 24.5-28.4 m/s, very high waves (20-30 ft) with overhanging crests, sea white with densely blown foam, heavy rolling, lowered visibility on sea surface, seldom experienced on land, trees broken or uprooted, (considerable structural damage) on land', 11)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (99, N'/97/', N'11', N'Violent Storm, wind speed 28.4-32.6 m/s, exceptionally high (30-45 ft) waves, foam patches cover sea, visibility more reduced', 11)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (100, N'/98/', N'12', N'Hurricane, wind speed >=32.6 m/s, air filled with foam, waves over 45 ft, sea completely white with driving spray, visibility greatly reduced', 11)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (101, N'/101/', N'Tropical Depression', N'A tropical cyclone in which the maximum sustained surface winds are 38 miles per hour (33 knots) or less. Characteristically having one or more closed isobars, it may form slowly from a tropical disturbance or an easterly wave which has continued to organize.', 12)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (102, N'/102/', N'Tropical Storm', N'A tropical cyclone in which the maximum sustained surface winds are from 39 miles per hour (34 knots) to 73 miles per hour (63 knots). At this point, the system is given a name to identify and track it.', 12)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (103, N'/103/', N'Hurricane', N'The name for a tropical cyclone with sustained winds of 74 miles per hour (65 knots) or greater in the North Atlantic Ocean, Caribbean Sea, Gulf of Mexico, and in the eastern North Pacific Ocean. This same tropical cyclone is known as a typhoon in the western Pacific and a cyclone in the Indian Ocean.', 12)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (104, N'/104/', N'Tropical Disturbance', N'An area of organized convection, originating in the tropics and occasionally the subtropics, that maintains its identity for 24 hours or more. It is often the first developmental stage of any subsequent tropical depression, tropical storm, or hurricane.', 12)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (106, N'/105/', N'Extratropical', N'Any cyclone that is no longer tropical in origin. Generally considered to be a migratory frontal cyclone found in the middle and high latitudes. An extratropical storm is a cyclone that no longer derives its energy source from the processes involved in sustaining a tropical cyclone, but thrives on baroclinic processes; i.e., the temperature contrast between warm and cold air masses.', 12)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (107, N'/107/', N'Tropical wave', N'A trough of low pressure in the trade-wind easterlies', 12)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (108, N'/108/', N'1', N'Winds 74-95 mph (64-82 kt or 119-153 km/hr). No significant damage to building structures. Damage primarily to unanchored mobile homes, shrubbery, and trees. Some damage to poorly constructed signs. Also, some coastal road flooding and minor pier damage.', 13)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (109, N'/109/', N'2', N'Winds 96-110 mph (83-95 kt or 154-177 km/hr). Some roofing material, door, and window damage of buildings. Considerable damage to shrubbery and trees with some trees blown down. Considerable damage to mobile homes, poorly constructed signs, and piers. Coastal and low-lying escape routes flood 2-4 hours before arrival of the hurricane center.', 13)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (112, N'/111/', N'3', N'Winds 111-130 mph (96-113 kt or 178-209 km/hr). Some structural damage to small residences and utility buildings with a minor amount of curtainwall failures. Damage to shrubbery and trees with foliage blown off trees and large trees blown down. Mobile homes and poorly constructed signs are destroyed. Terrain continuously lower than 5 ft above mean sea level may be flooded inland 8 miles (13 km) or more. ', 13)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (113, N'/112/', N'4', N'Winds 131-155 mph (114-135 kt or 210-249 km/hr). More extensive curtainwall failures with some complete roof structure failures on small residences. Shrubs, trees, and all signs are blown down. Complete destruction of mobile homes. Extensive damage to doors and windows. Terrain lower than 10 ft above sea level may be flooded requiring massive evacuation of residential areas as far inland as 6 miles (10 km). ', 13)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (114, N'/113/', N'5', N'Winds greater than 155 mph (135 kt or 249 km/hr). Complete roof failure on many residences and industrial buildings. Some complete building failures with small utility buildings blown over or away. Complete destruction of mobile homes.  Major damage to lower floors of all structures located less than 15 ft above sea level and within 500 yards of the shoreline. Massive evacuation of residential areas on low ground within 5-10 miles (8-16 km) of the shoreline may be required. ', 13)
INSERT [ODData].[ObservedCategory] ([CategoryID], [HierarchyCode], [CategoryCode], [CategoryDescription], [ClassificationSchemeID]) VALUES (115, N'/114/', N'-9999', N'Missing or does not fall into any relevant category', 14)
SET IDENTITY_INSERT [ODData].[ObservedCategory] OFF
